<?php

class Suggestion {

    protected $main_table = 'data_suggestion';
    protected $main_id = 'sug_id';
    protected $db = null;

    public function __construct($db) {
	$this->db = $db;
    }

    public function __destruct() {
	unset($this->db);
    }

    public function get_table_name() {
	return $this->main_table;
    }

    /**
     * 	insert Suggestion
     * 	@param array $data 
     * 	@return int affected count
     */
    public function insert_data($data) {
	if (!is_array($data))
	    my_jump('輸入的參數有誤');
	$rows = $this->db->insert($this->main_table, $data);
	$insert_id = $this->db->getInsertId();
	return $insert_id;
    }

    /**
     * 	update Suggestion
     * 	@param array $data 
     * 	@param string $where 
     * 	@return int affected count
     */
    public function update_data($data, $where) {
	if (!is_array($data))
	    my_jump('輸入的參數有誤');
	$result = $this->db->update($this->main_table, $data, $where);
	return $result;
    }

    /**
     * 	delete Suggestion
     * 	@param string $where 
     * 	@return int affected count
     */
    public function del_data($where) {
	$result = $this->db->delete($this->main_table, $where);
	return $result;
    }

    

    /**
     * 	get Suggestion info
     * 	@param int $id 
     * 	@param array/string $field
     * 	@return array one row data
     */
    public function get_data_row($id, $field = '*') {
	if (!intval($id))
	    my_jump('輸入的參數有誤!');
	$sql = "SELECT " . $field . " FROM " . $this->main_table . " WHERE " . $this->main_id . "='" . intval($id) . "' ";
	$data = $this->db->getRow($sql);
	return $data;
    }

    /**
     * 	get Suggestion array
     * 	@param string $where
     * 	@return array data
     */
    public function get_data_array($where, $order = 'sg_id DESC', $limit = '10', $field = '*') {
	$sql = "SELECT " . $field . " FROM " . $this->main_table . " WHERE " . $where . " ORDER BY " . $order;
	if (intval($limit)) {
	    $sql .= " LIMIT " . $limit;
	}
	$data = $this->db->getAll($sql);
	return $data;
    }

   

}

?>